Job codes dimension

This dimension includes records for all of the job codes within your organization. Each job code represents a job position or role within the organization.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system. For more information, see Editing a dimension using a spreadsheet.

Accessing the dimension

From the Enterprise Decision Support home page, in the Data control section, select Maintain data > Core dimensions > Job codes.

The page can only show up to a maximum of 10,000 records.

Filtering records

To filter records

  1. Select the funnel icon in the upper left corner of the page.

  2. In the Filter box, you can narrow down the records to appear by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, select Edit. If you are familiar with writing filter statements, you can enter the statement syntax directly in the Filter box.
  3. Select Apply.

Adding or editing a job code

Due to the large number of records that this table can contain, you might need to use the Filter function previously described to find the desired records.

To edit a job code

  1. In the table, do any of the following:

    • To add a job code, select + Add Row. The new row appears at the top of the table.

      IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.

    • To edit a job code, to open cell(s) for changes, select the edit icon in the Actions column.

      NOTE: You cannot edit columns that are grayed out.

  2. Complete the columns, as needed. A description of each column is located in the following "Column descriptions" section.
  3. To cancel the changes made, select the cancel icon in the Actions column. Otherwise, to save them, select the save icon in the Actions column.
  4. When you finish making changes, select Save. After you save, the table shows any new job codes in order by the JOBCODE column.

Deleting a job code

Due to the large number of records that this table can contain, you might need to use the Filter function previously described to find the desired records.

To delete a job code

  1. Find the job code to be deleted, and select the delete icon in the Actions column.

  2. At the Confirm Delete prompt, select OK.
  3. When you finish making changes, select Save.

Column descriptions

The following section describes the areas and columns in the table:

NOTE: The table may display some columns that are related to other Syntellis products, or have been created specifically for your organization. If you need help with these columns, contact your Syntellis Implementation Consultant or Syntellis Support.

Keys

Every table in the database must have at least one key column. Key columns define unique records of data in the table. If a table has one key column, then each value in that key column must be unique, and defines a unique record in the table. If a table has multiple key columns, then each combination of values in those key columns defines a unique record in the table.

JOBCODE - Axiom Software job code. This entry must be an alphanumeric field so that, during the import process, a J is prepended to all job codes to ensure they are alphanumeric.

The system will not let you save the table if an entry includes one or more of the following:

  • More than the maximum allowed characters
  • Contains one of these characters: \\ / < > : ? | * ' \"
  • Begins with + - =

Description - Job code description from the payroll system.

TIP: To help make reports more readable, we recommend that you do not use all capital letters in the description content.

Cost

These columns are specific to the set up and maintenance of Axiom Enterprise Decision Support.

Variable - Determines whether the job code is a fixed or variable cost.

Other

JobClass - Major job classes of individual job codes. You can use this to apply salary increases for specific groups. Commonly used entries include the following:

  • Management
  • Physician
  • Professional
  • Technical
  • RN
  • LPN
  • Assistant
  • Support
  • Other
  • Clerical
  • Contract

GLClass - Used to identify the GL class each job code is assigned to for budget and reporting salary-mapping purposes. The exception-mapping table is located in the GLPayrollMapping table. If mapping payroll by job code or pay type is not an option, this mapping table allows for special exceptions for payroll mapping.